public class Data {
    
    private String dsn, usu, pwd;
    private java.sql.Connection con;
    private static final String ODBC_DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
    
    public java.sql.Connection getConnection() { return con; }
    
    
    public boolean abrirConexion() {
        String url = "jdbc:odbc:".concat(IJDBC.DSN);
        try {
            con = java.sql.DriverManager.getConnection(url,IJDBC.USU,IJDBC.PAS);
            return true;
        } catch( java.sql.SQLException e ) { 
        	e.printStackTrace();
            return false;
        }
    }
    
    public boolean cerrarConexion() {
        try {
            con.close();
            return true;
        } catch( java.sql.SQLException e ) { 
            return false;
        }
    }
    
     public static void driverOdbc() {
        try {
            Class.forName(IJDBC.DRIVER);
        } catch( ClassNotFoundException e ) { }
    }
    


	public static Object getInstance() {
		// TODO Auto-generated method stub
		return null;
	}    
}